﻿CREATE TABLE [dbo].[Basket] (
    [Id]               INT           IDENTITY (1, 1) NOT NULL,
    [Customer_Id]      INT           NOT NULL,
    [Item_Code]        NVARCHAR (20) NOT NULL,
    [Item_Description] NVARCHAR (50) NULL,
    [UnitPrice]        MONEY         NOT NULL,
    [Quantity]         FLOAT (53)    NOT NULL,
    CONSTRAINT [PK_Basket] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Basket_Customer] FOREIGN KEY ([Customer_Id]) REFERENCES [dbo].[Customer] ([Id])
);

